Pandas Profiling Report

Dataset statistics

Number of variables	14
Number of observations	9578
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.0 MiB
Average record size in memory	112.0 B

Variable types

Categorical	3
Numeric	11

Warnings

`credit_policy` is highly correlated with `inq_last_6mths`	High correlation
`int_rate` is highly correlated with `fico`	High correlation
`fico` is highly correlated with `int_rate` and 1 other fields	High correlation
`revol_util` is highly correlated with `fico`	High correlation
`inq_last_6mths` is highly correlated with `credit_policy`	High correlation
`int_rate` is highly correlated with `fico`	High correlation
`fico` is highly correlated with `int_rate` and 1 other fields	High correlation
`revol_bal` is highly correlated with `revol_util`	High correlation
`revol_util` is highly correlated with `fico` and 1 other fields	High correlation
`int_rate` is highly correlated with `fico`	High correlation
`fico` is highly correlated with `int_rate`	High correlation
`inq_last_6mths` is highly correlated with `credit_policy`	High correlation
`credit_policy` is highly correlated with `inq_last_6mths` and 1 other fields	High correlation
`fico` is highly correlated with `credit_policy` and 2 other fields	High correlation
`int_rate` is highly correlated with `fico` and 1 other fields	High correlation
`revol_util` is highly correlated with `fico` and 1 other fields	High correlation
`revol_bal` has 321 (3.4%) zeros	Zeros
`revol_util` has 297 (3.1%) zeros	Zeros
`inq_last_6mths` has 3637 (38.0%) zeros	Zeros
`delinq_2yrs` has 8458 (88.3%) zeros	Zeros
`pub_rec` has 9019 (94.2%) zeros	Zeros

Reproduction

Analysis started	2021-11-19 07:40:32.582965
Analysis finished	2021-11-19 07:41:13.915581
Duration	41.33 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

credit_policy
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	75.0 KiB

1	7710
0	1868

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	9578
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	7710	80.5%
0	1868	19.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1	7710	80.5%
0	1868	19.5%

Most occurring characters

Value	Count	Frequency (%)
1	7710	80.5%
0	1868	19.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	9578	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	7710	80.5%
0	1868	19.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	9578	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	7710	80.5%
0	1868	19.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9578	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	7710	80.5%
0	1868	19.5%

purpose
Categorical

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	75.0 KiB

debt_consolidation	3957
all_other	2331
credit_card	1262
home_improvement	629
small_business	619
Other values (2)	780

Length

Max length	18
Median length	14
Mean length	14.06431405
Min length	9

Characters and Unicode

Total characters	134708
Distinct characters	19
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	debt_consolidation
2nd row	credit_card
3rd row	debt_consolidation
4th row	debt_consolidation
5th row	credit_card

Common Values

Value	Count	Frequency (%)
debt_consolidation	3957	41.3%
all_other	2331	24.3%
credit_card	1262	13.2%
home_improvement	629	6.6%
small_business	619	6.5%
major_purchase	437	4.6%
educational	343	3.6%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
debt_consolidation	3957	41.3%
all_other	2331	24.3%
credit_card	1262	13.2%
home_improvement	629	6.6%
small_business	619	6.5%
major_purchase	437	4.6%
educational	343	3.6%

Most occurring characters

Value	Count	Frequency (%)
o	16240	12.1%
t	12479	9.3%
e	10836	8.0%
d	10781	8.0%
i	10767	8.0%
l	10200	7.6%
a	9729	7.2%
n	9505	7.1%
_	9235	6.9%
c	7261	5.4%
Other values (9)	27675	20.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	125473	93.1%
Connector Punctuation	9235	6.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	16240	12.9%
t	12479	9.9%
e	10836	8.6%
d	10781	8.6%
i	10767	8.6%
l	10200	8.1%
a	9729	7.8%
n	9505	7.6%
c	7261	5.8%
s	6870	5.5%
Other values (8)	20805	16.6%

Connector Punctuation

Value	Count	Frequency (%)
_	9235	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	125473	93.1%
Common	9235	6.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	16240	12.9%
t	12479	9.9%
e	10836	8.6%
d	10781	8.6%
i	10767	8.6%
l	10200	8.1%
a	9729	7.8%
n	9505	7.6%
c	7261	5.8%
s	6870	5.5%
Other values (8)	20805	16.6%

Common

Value	Count	Frequency (%)
_	9235	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	134708	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	16240	12.1%
t	12479	9.3%
e	10836	8.0%
d	10781	8.0%
i	10767	8.0%
l	10200	7.6%
a	9729	7.2%
n	9505	7.1%
_	9235	6.9%
c	7261	5.4%
Other values (9)	27675	20.5%

int_rate
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	249
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1226400606

Minimum	0.06
Maximum	0.2164
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	75.0 KiB

Quantile statistics

Minimum	0.06
5-th percentile	0.0774
Q1	0.1039
median	0.1221
Q3	0.1407
95-th percentile	0.167
Maximum	0.2164
Range	0.1564
Interquartile range (IQR)	0.0368

Descriptive statistics

Standard deviation	0.02684698721
Coefficient of variation (CV)	0.2189087896
Kurtosis	-0.2243235112
Mean	0.1226400606
Median Absolute Deviation (MAD)	0.0186
Skewness	0.1644199135
Sum	1174.6465
Variance	0.0007207607224
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.1253	354	3.7%
0.0894	299	3.1%
0.1183	243	2.5%
0.1218	215	2.2%
0.0963	210	2.2%
0.1114	206	2.2%
0.08	198	2.1%
0.1287	197	2.1%
0.1148	193	2.0%
0.0859	187	2.0%
Other values (239)	7276	76.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.06	8	0.1%
0.0639	4	< 0.1%
0.0676	9	0.1%
0.0705	23	0.2%
0.0712	9	0.1%
0.0714	28	0.3%
0.0737	32	0.3%
0.074	72	0.8%
0.0743	33	0.3%
0.0751	38	0.4%

Value	Count	Frequency (%)
0.2164	2	< 0.1%
0.2121	7	0.1%
0.209	2	< 0.1%
0.2086	6	0.1%
0.2052	4	< 0.1%
0.2017	6	0.1%
0.2016	1	< 0.1%
0.2011	9	0.1%
0.1982	8	0.1%
0.1979	6	0.1%

installment
Real number (ℝ_≥0)

Distinct	4788
Distinct (%)	50.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	319.0894132

Minimum	15.67
Maximum	940.14
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	75.0 KiB

Quantile statistics

Minimum	15.67
5-th percentile	65.5595
Q1	163.77
median	268.95
Q3	432.7625
95-th percentile	756.2655
Maximum	940.14
Range	924.47
Interquartile range (IQR)	268.9925

Descriptive statistics

Standard deviation	207.0713015
Coefficient of variation (CV)	0.6489444429
Kurtosis	0.1379077383
Mean	319.0894132
Median Absolute Deviation (MAD)	124.7
Skewness	0.9125224624
Sum	3056238.4
Variance	42878.5239
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
317.72	41	0.4%
316.11	34	0.4%
319.47	29	0.3%
381.26	27	0.3%
662.68	27	0.3%
156.1	24	0.3%
320.95	24	0.3%
334.67	23	0.2%
669.33	23	0.2%
188.02	23	0.2%
Other values (4778)	9303	97.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
15.67	1	< 0.1%
15.69	1	< 0.1%
15.75	1	< 0.1%
15.76	1	< 0.1%
15.91	1	< 0.1%
16.08	1	< 0.1%
16.25	1	< 0.1%
16.31	1	< 0.1%
16.47	1	< 0.1%
16.73	1	< 0.1%

Value	Count	Frequency (%)
940.14	1	< 0.1%
926.83	2	< 0.1%
922.42	1	< 0.1%
918.02	2	< 0.1%
916.95	2	< 0.1%
914.42	2	< 0.1%
913.63	3	< 0.1%
910.44	1	< 0.1%
909.25	1	< 0.1%
907.6	2	< 0.1%

log_annual_inc
Real number (ℝ_≥0)

Distinct	1987
Distinct (%)	20.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.93211714

Minimum	7.547501683
Maximum	14.52835448
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	75.0 KiB

Quantile statistics

Minimum	7.547501683
5-th percentile	9.917893268
Q1	10.55841352
median	10.92888357
Q3	11.29129292
95-th percentile	11.91839057
Maximum	14.52835448
Range	6.980852797
Interquartile range (IQR)	0.7328793975

Descriptive statistics

Standard deviation	0.6148127514
Coefficient of variation (CV)	0.05623912949
Kurtosis	1.609004138
Mean	10.93211714
Median Absolute Deviation (MAD)	0.366945765
Skewness	0.02866810657
Sum	104707.8179
Variance	0.3779947192
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11.00209984	308	3.2%
10.81977828	248	2.6%
10.30895266	224	2.3%
10.59663473	224	2.3%
10.71441777	221	2.3%
11.22524339	196	2.0%
11.15625052	165	1.7%
10.77895629	149	1.6%
10.91508846	147	1.5%
11.08214255	146	1.5%
Other values (1977)	7550	78.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
7.547501683	1	< 0.1%
7.60090246	1	< 0.1%
8.101677747	1	< 0.1%
8.160518247	1	< 0.1%
8.188689124	1	< 0.1%
8.29404964	3	< 0.1%
8.342839804	1	< 0.1%
8.411832676	1	< 0.1%
8.476371197	2	< 0.1%
8.494538501	1	< 0.1%

Value	Count	Frequency (%)
14.52835448	1	< 0.1%
14.18015367	1	< 0.1%
14.12446477	1	< 0.1%
13.99783211	1	< 0.1%
13.71015004	2	< 0.1%
13.5670492	2	< 0.1%
13.54370183	1	< 0.1%
13.48700649	1	< 0.1%
13.47019937	1	< 0.1%
13.45883561	3	< 0.1%

dti
Real number (ℝ_≥0)

Distinct	2529
Distinct (%)	26.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.60667885

Minimum	0
Maximum	29.96
Zeros	89
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	75.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1.27
Q1	7.2125
median	12.665
Q3	17.95
95-th percentile	23.65
Maximum	29.96
Range	29.96
Interquartile range (IQR)	10.7375

Descriptive statistics

Standard deviation	6.883969541
Coefficient of variation (CV)	0.5460573418
Kurtosis	-0.9003553617
Mean	12.60667885
Median Absolute Deviation (MAD)	5.385
Skewness	0.02394102295
Sum	120746.77
Variance	47.38903664
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	89	0.9%
10	19	0.2%
0.6	16	0.2%
15.1	13	0.1%
12	13	0.1%
13.16	13	0.1%
6	13	0.1%
19.2	13	0.1%
10.8	12	0.1%
15.6	12	0.1%
Other values (2519)	9365	97.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	89	0.9%
0.01	1	< 0.1%
0.02	1	< 0.1%
0.03	1	< 0.1%
0.04	2	< 0.1%
0.05	1	< 0.1%
0.07	3	< 0.1%
0.08	2	< 0.1%
0.09	2	< 0.1%
0.12	2	< 0.1%

Value	Count	Frequency (%)
29.96	1	< 0.1%
29.95	1	< 0.1%
29.9	1	< 0.1%
29.74	1	< 0.1%
29.72	1	< 0.1%
29.7	2	< 0.1%
29.6	1	< 0.1%
29.47	1	< 0.1%
29.42	1	< 0.1%
29.41	1	< 0.1%

fico
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	44
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	710.8463145

Minimum	612
Maximum	827
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	75.0 KiB

Quantile statistics

Minimum	612
5-th percentile	657
Q1	682
median	707
Q3	737
95-th percentile	782
Maximum	827
Range	215
Interquartile range (IQR)	55

Descriptive statistics

Standard deviation	37.97053723
Coefficient of variation (CV)	0.05341595849
Kurtosis	-0.4223123103
Mean	710.8463145
Median Absolute Deviation (MAD)	25
Skewness	0.4712597399
Sum	6808486
Variance	1441.761697
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=44)

Value	Count	Frequency (%)
687	548	5.7%
682	536	5.6%
692	498	5.2%
697	476	5.0%
702	472	4.9%
707	444	4.6%
667	438	4.6%
677	427	4.5%
717	424	4.4%
662	414	4.3%
Other values (34)	4901	51.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
612	2	< 0.1%
617	1	< 0.1%
622	1	< 0.1%
627	2	< 0.1%
632	6	0.1%
637	5	0.1%
642	102	1.1%
647	112	1.2%
652	131	1.4%
657	127	1.3%

Value	Count	Frequency (%)
827	1	< 0.1%
822	5	0.1%
817	6	0.1%
812	33	0.3%
807	45	0.5%
802	55	0.6%
797	76	0.8%
792	97	1.0%
787	85	0.9%
782	118	1.2%

days_with_cr_line
Real number (ℝ_≥0)

Distinct	2687
Distinct (%)	28.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4560.767197

Minimum	178.9583333
Maximum	17639.95833
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	75.0 KiB

Quantile statistics

Minimum	178.9583333
5-th percentile	1320.041667
Q1	2820
median	4139.958333
Q3	5730
95-th percentile	9329.958333
Maximum	17639.95833
Range	17461
Interquartile range (IQR)	2910

Descriptive statistics

Standard deviation	2496.930377
Coefficient of variation (CV)	0.5474803403
Kurtosis	1.937860594
Mean	4560.767197
Median Absolute Deviation (MAD)	1440.083334
Skewness	1.155748227
Sum	43683028.21
Variance	6234661.307
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3660	50	0.5%
3630	48	0.5%
3990	46	0.5%
4410	44	0.5%
3600	41	0.4%
2550	38	0.4%
4080	38	0.4%
1800	37	0.4%
3690	37	0.4%
4020	35	0.4%
Other values (2677)	9164	95.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
178.9583333	1	< 0.1%
180.0416667	3	< 0.1%
181	1	< 0.1%
183.0416667	1	< 0.1%
209.0416667	1	< 0.1%
210	1	< 0.1%
212.0416667	1	< 0.1%
238.9583333	5	0.1%
240.0416667	1	< 0.1%
291.9583333	1	< 0.1%

Value	Count	Frequency (%)
17639.95833	1	< 0.1%
17616	1	< 0.1%
16652	1	< 0.1%
16350	1	< 0.1%
16260	1	< 0.1%
16259.04167	1	< 0.1%
16213	1	< 0.1%
15990	1	< 0.1%
15692	1	< 0.1%
15420.95833	1	< 0.1%

revol_bal
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	7869
Distinct (%)	82.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16913.96388

Minimum	0
Maximum	1207359
Zeros	321
Zeros (%)	3.4%
Negative	0
Negative (%)	0.0%
Memory size	75.0 KiB

Quantile statistics

Minimum	0
5-th percentile	127.7
Q1	3187
median	8596
Q3	18249.5
95-th percentile	57654.3
Maximum	1207359
Range	1207359
Interquartile range (IQR)	15062.5

Descriptive statistics

Standard deviation	33756.18956
Coefficient of variation (CV)	1.995758641
Kurtosis	259.655203
Mean	16913.96388
Median Absolute Deviation (MAD)	6488
Skewness	11.16105849
Sum	162001946
Variance	1139480333
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	321	3.4%
298	10	0.1%
255	10	0.1%
682	9	0.1%
346	8	0.1%
2229	6	0.1%
182	6	0.1%
1085	6	0.1%
8035	5	0.1%
1	5	0.1%
Other values (7859)	9192	96.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	321	3.4%
1	5	0.1%
2	2	< 0.1%
3	1	< 0.1%
4	2	< 0.1%
5	4	< 0.1%
6	5	0.1%
7	1	< 0.1%
9	4	< 0.1%
10	3	< 0.1%

Value	Count	Frequency (%)
1207359	1	< 0.1%
952013	1	< 0.1%
602519	1	< 0.1%
508961	1	< 0.1%
407794	1	< 0.1%
401941	1	< 0.1%
394107	1	< 0.1%
388892	1	< 0.1%
385489	1	< 0.1%
374487	1	< 0.1%

revol_util
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	1035
Distinct (%)	10.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	46.79923575

Minimum	0
Maximum	119
Zeros	297
Zeros (%)	3.1%
Negative	0
Negative (%)	0.0%
Memory size	75.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1.1
Q1	22.6
median	46.3
Q3	70.9
95-th percentile	94
Maximum	119
Range	119
Interquartile range (IQR)	48.3

Descriptive statistics

Standard deviation	29.01441697
Coefficient of variation (CV)	0.6199762988
Kurtosis	-1.116466996
Mean	46.79923575
Median Absolute Deviation (MAD)	24.2
Skewness	0.05998544258
Sum	448243.08
Variance	841.8363919
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	297	3.1%
0.5	26	0.3%
47.8	22	0.2%
0.3	22	0.2%
73.7	22	0.2%
3.3	21	0.2%
0.1	21	0.2%
0.7	20	0.2%
1	20	0.2%
0.2	20	0.2%
Other values (1025)	9087	94.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	297	3.1%
0.04	1	< 0.1%
0.1	21	0.2%
0.2	20	0.2%
0.3	22	0.2%
0.4	12	0.1%
0.5	26	0.3%
0.6	12	0.1%
0.7	20	0.2%
0.8	14	0.1%

Value	Count	Frequency (%)
119	1	< 0.1%
108.8	1	< 0.1%
106.5	1	< 0.1%
106.4	1	< 0.1%
106.2	1	< 0.1%
106.1	1	< 0.1%
105.7	1	< 0.1%
105.3	1	< 0.1%
105.2	1	< 0.1%
104.3	1	< 0.1%

inq_last_6mths
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	28
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.5774692

Minimum	0
Maximum	33
Zeros	3637
Zeros (%)	38.0%
Negative	0
Negative (%)	0.0%
Memory size	75.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	5
Maximum	33
Range	33
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.200245315
Coefficient of variation (CV)	1.394794469
Kurtosis	26.28813144
Mean	1.5774692
Median Absolute Deviation (MAD)	1
Skewness	3.584150856
Sum	15109
Variance	4.841079446
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
0	3637	38.0%
1	2462	25.7%
2	1384	14.4%
3	864	9.0%
4	475	5.0%
5	278	2.9%
6	165	1.7%
7	100	1.0%
8	72	0.8%
9	47	0.5%
Other values (18)	94	1.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3637	38.0%
1	2462	25.7%
2	1384	14.4%
3	864	9.0%
4	475	5.0%
5	278	2.9%
6	165	1.7%
7	100	1.0%
8	72	0.8%
9	47	0.5%

Value	Count	Frequency (%)
33	1	< 0.1%
32	1	< 0.1%
31	1	< 0.1%
28	1	< 0.1%
27	1	< 0.1%
25	1	< 0.1%
24	2	< 0.1%
20	1	< 0.1%
19	2	< 0.1%
18	4	< 0.1%

delinq_2yrs
Real number (ℝ_≥0)

ZEROS

Distinct	11
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1637084986

Minimum	0
Maximum	13
Zeros	8458
Zeros (%)	88.3%
Negative	0
Negative (%)	0.0%
Memory size	75.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	13
Range	13
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.5462149246
Coefficient of variation (CV)	3.336509278
Kurtosis	71.43318185
Mean	0.1637084986
Median Absolute Deviation (MAD)	0
Skewness	6.061793276
Sum	1568
Variance	0.2983507439
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	8458	88.3%
1	832	8.7%
2	192	2.0%
3	65	0.7%
4	19	0.2%
5	6	0.1%
6	2	< 0.1%
13	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8458	88.3%
1	832	8.7%
2	192	2.0%
3	65	0.7%
4	19	0.2%
5	6	0.1%
6	2	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
13	1	< 0.1%
11	1	< 0.1%
8	1	< 0.1%
7	1	< 0.1%
6	2	< 0.1%
5	6	0.1%
4	19	0.2%
3	65	0.7%
2	192	2.0%
1	832	8.7%

pub_rec
Real number (ℝ_≥0)

ZEROS

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0621215285

Minimum	0
Maximum	5
Zeros	9019
Zeros (%)	94.2%
Negative	0
Negative (%)	0.0%
Memory size	75.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	5
Range	5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.2621263264
Coefficient of variation (CV)	4.219573032
Kurtosis	38.7810072
Mean	0.0621215285
Median Absolute Deviation (MAD)	0
Skewness	5.12643446
Sum	595
Variance	0.06871021098
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	9019	94.2%
1	533	5.6%
2	19	0.2%
3	5	0.1%
4	1	< 0.1%
5	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	9019	94.2%
1	533	5.6%
2	19	0.2%
3	5	0.1%
4	1	< 0.1%
5	1	< 0.1%

Value	Count	Frequency (%)
5	1	< 0.1%
4	1	< 0.1%
3	5	0.1%
2	19	0.2%
1	533	5.6%
0	9019	94.2%

not_fully_paid
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	75.0 KiB

0	8045
1	1533

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	9578
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	8045	84.0%
1	1533	16.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	8045	84.0%
1	1533	16.0%

Most occurring characters

Value	Count	Frequency (%)
0	8045	84.0%
1	1533	16.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	9578	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	8045	84.0%
1	1533	16.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	9578	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	8045	84.0%
1	1533	16.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9578	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	8045	84.0%
1	1533	16.0%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	credit_policy	purpose	int_rate	installment	log_annual_inc	dti	fico	days_with_cr_line	revol_bal	revol_util	inq_last_6mths	delinq_2yrs	pub_rec	not_fully_paid
0	1	debt_consolidation	0.1189	829.10	11.350407	19.48	737	5639.958333	28854	52.1	0	0	0	0
1	1	credit_card	0.1071	228.22	11.082143	14.29	707	2760.000000	33623	76.7	0	0	0	0
2	1	debt_consolidation	0.1357	366.86	10.373491	11.63	682	4710.000000	3511	25.6	1	0	0	0
3	1	debt_consolidation	0.1008	162.34	11.350407	8.10	712	2699.958333	33667	73.2	1	0	0	0
4	1	credit_card	0.1426	102.92	11.299732	14.97	667	4066.000000	4740	39.5	0	1	0	0
5	1	credit_card	0.0788	125.13	11.904968	16.98	727	6120.041667	50807	51.0	0	0	0	0
6	1	debt_consolidation	0.1496	194.02	10.714418	4.00	667	3180.041667	3839	76.8	0	0	1	1
7	1	all_other	0.1114	131.22	11.002100	11.08	722	5116.000000	24220	68.6	0	0	0	1
8	1	home_improvement	0.1134	87.19	11.407565	17.25	682	3989.000000	69909	51.1	1	0	0	0
9	1	debt_consolidation	0.1221	84.12	10.203592	10.00	707	2730.041667	5630	23.0	1	0	0	0

Last rows

	purpose	int_rate	installment	log_annual_inc	dti	fico	days_with_cr_line	revol_bal	revol_util	inq_last_6mths	pub_rec	not_fully_paid
9568	all_other	0.1979	37.06	10.645425	22.17	667	5916.000000	28854	59.8	6	1	0
9569	home_improvement	0.1426	823.34	12.429216	3.62	722	3239.958333	33575	83.9	5	0	1
9570	all_other	0.1671	113.63	10.645425	28.06	672	3210.041667	25759	63.8	5	0	1
9571	all_other	0.1568	161.01	11.225243	8.00	677	7230.000000	6909	29.2	4	1	1
9572	debt_consolidation	0.1565	69.98	10.110472	7.02	662	8190.041667	2999	39.5	6	0	1
9573	all_other	0.1461	344.76	12.180755	10.39	672	10474.000000	215372	82.1	2	0	1
9574	all_other	0.1253	257.70	11.141862	0.21	722	4380.000000	184	1.1	5	0	1
9575	debt_consolidation	0.1071	97.81	10.596635	13.09	687	3450.041667	10036	82.9	8	0	1
9576	home_improvement	0.1600	351.58	10.819778	19.18	692	1800.000000	0	3.2	5	0	1
9577	debt_consolidation	0.1392	853.43	11.264464	16.28	732	4740.000000	37879	57.0	6	0	1

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows